<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_attribute`;");
E_C("CREATE TABLE `ecs_attribute` (
  `attr_id` smallint(5) unsigned NOT NULL auto_increment,
  `cat_id` smallint(5) unsigned NOT NULL default '0',
  `attr_name` varchar(60) NOT NULL default '',
  `attr_input_type` tinyint(1) unsigned NOT NULL default '1',
  `attr_type` tinyint(1) unsigned NOT NULL default '1',
  `attr_values` text NOT NULL,
  `attr_index` tinyint(1) unsigned NOT NULL default '0',
  `sort_order` tinyint(3) unsigned NOT NULL default '0',
  `is_linked` tinyint(1) unsigned NOT NULL default '0',
  `attr_group` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`attr_id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_attribute` values('11','6','保质期','1','1','30（天）\r\n60（天）\r\n90（天）\r\n120（天）\r\n360（天）','0','0','0','0');");
E_D("replace into `ecs_attribute` values('10','6','产地','1','0','中国\r\n美国\r\n澳大利亚\r\n巴西\r\n法国\r\n英国\r\n俄罗斯\r\n日本','0','0','0','0');");
E_D("replace into `ecs_attribute` values('9','6','重量','1','1','400g\r\n600g\r\n800g\r\n1000g','0','0','0','0');");
E_D("replace into `ecs_attribute` values('12','6','存储条件','1','0','常温\r\n冷冻','0','0','0','0');");
E_D("replace into `ecs_attribute` values('13','6','销售单位','1','0','两\r\n斤\r\n袋','0','0','0','0');");

require("../../inc/footer.php");
?>